package cn.genmer.test.security.model;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.hibernate.annotations.TypeDef;

import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import java.sql.Timestamp;
import java.time.LocalDateTime;
import java.util.Date;

@Entity
@Data
@AllArgsConstructor
@NoArgsConstructor
@Table(name = "RESOURCE_APPS")
//@TypeDef(name = "JsonbType", typeClass = JsonbType.class)
public class MINING_APPLY {
    /**
     *
     * 主键索引
     *
     * @mbggenerated
     */
    @Id
    private String objuid;

    /**
     *
     * APP/DATA/CK_GUID
     *
     * @mbggenerated
     */
    private String ck_guid;

    /**
     *
     * APP/DATA/许可证号
     *
     * @mbggenerated
     */
    private String id_licenceid;

    /**
     *
     * APP/DATA/项目档案号
     *
     * @mbggenerated
     */
    private String id_item_archives_code;

    /**
     *
     * APP/DATA/项目类型
     *
     * @mbggenerated
     */
    private String in_item_type;

    /**
     *
     * APP/DATA/申请人
     *
     * @mbggenerated
     */
    private String na_apply_person;

    /**
     *
     * APP/DATA/地址
     *
     * @mbggenerated
     */
    private String na_address;

    /**
     *
     * APP/DATA/矿山名称
     *
     * @mbggenerated
     */
    private String na_mine_name;

    /**
     *
     * APP/DATA/东经起
     *
     * @mbggenerated
     */
    private Double qt_longeast_start;

    /**
     *
     * APP/DATA/东经止
     *
     * @mbggenerated
     */
    private Double qt_longeast_end;

    /**
     *
     * APP/DATA/北纬起
     *
     * @mbggenerated
     */
    private Double qt_latnorth_start;

    /**
     *
     * APP/DATA/北纬止
     *
     * @mbggenerated
     */
    private Double qt_latnorth_end;

    /**
     *
     * APP/DATA/经济类型
     *
     * @mbggenerated
     */
    private Integer in_economy_type;

    /**
     *
     * APP/DATA/设计年限
     *
     * @mbggenerated
     */
    private Double qt_design_year;

    /**
     *
     * APP/DATA/开采主矿种
     *
     * @mbggenerated
     */
    private Integer qt_main_mine;

    /**
     *
     * APP/DATA/其它主矿种
     *
     * @mbggenerated
     */
    private String na_other_mine;

    /**
     *
     * APP/DATA/设计规模
     *
     * @mbggenerated
     */
    private Double qt_design_scope;

    /**
     *
     * APP/DATA/开采方式
     *
     * @mbggenerated
     */
    private String na_mine_mode;

    /**
     *
     * APP/DATA/采矿方法
     *
     * @mbggenerated
     */
    private String na_mining;

    /**
     *
     * APP/DATA/选矿方法
     *
     * @mbggenerated
     */
    private String na_mill;

    /**
     *
     * APP/DATA/区域坐标
     *
     * @mbggenerated
     */
    private String na_area_coordinate;

    /**
     *
     * APP/DATA/采深上限
     *
     * @mbggenerated
     */
    private Double qt_deep_up;

    /**
     *
     * APP/DATA/采深下限
     *
     * @mbggenerated
     */
    private Double qt_deep_down;

    /**
     *
     * APP/DATA/矿区面积
     *
     * @mbggenerated
     */
    private Double qt_digings_area;

    /**
     *
     * APP/DATA/受理日期
     *
     * @mbggenerated
     */
    private LocalDateTime dt_recive_date;
    /**
     *
     * APP/DATA/有效期限
     *
     * @mbggenerated
     */
    private String na_usefullife;

    /**
     *
     * APP/DATA/有效期起
     *
     * @mbggenerated
     */
    private LocalDateTime dt_usefullife_start;

    /**
     *
     * APP/DATA/有效期止
     *
     * @mbggenerated
     */
    private LocalDateTime dt_usefullife_end;

    /**
     *
     * APP/DATA/变更类型
     *
     * @mbggenerated
     */
    private String na_change_type;

    /**
     *
     * APP/DATA/所在行政区
     *
     * @mbggenerated
     */
    private String qt_canton;

    /**
     *
     * APP/DATA/采矿权取得方式
     *
     * @mbggenerated
     */
    private String na_mine_kind;

    /**
     *
     * 发证机关名称
     *
     * @mbggenerated
     */
    private String approve_org;

    /**
     *
     * 发证机关编码
     *
     * @mbggenerated
     */
    private String approve_org_code;

    /**
     *
     *   值等于有子项目且配号成功且未公告的项目OBJUID
     *
     * @mbggenerated
     */
    private String id_mack_uid;

    /**
     *
     * 公告时间
     *
     * @mbggenerated
     */
    private LocalDateTime dt_broadcast;

    /**
     *
     * APP/DATA/采矿权使用费
     *
     * @mbggenerated
     */
    private Double qt_mining_usefee;

    /**
     *
     * APP/DATA/原签发时间
     *
     * @mbggenerated
     */
    private LocalDateTime dt_old_signature_date;

    /**
     *
     * APP/DATA/签发时间
     *
     * @mbggenerated
     */
    private LocalDateTime dt_signature_date;

    /**
     *
     * APP/DATA/原许可证号
     *
     * @mbggenerated
     */
    private String id_old_licenceid;

    /**
     *
     * APP/DATA/共伴生类型
     *
     * @mbggenerated
     */
    private Integer in_mine_type;

    /**
     *
     * APP/DATA/取得方式代码
     *
     * @mbggenerated
     */
    private Integer qt_mine_kind;

    /**
     *
     * APP/DATA/储量单位
     *
     * @mbggenerated
     */
    private String na_reserves_unit;

    /**
     *
     * APP/DATA/矿石类型 (名称)
     *
     * @mbggenerated
     */
    private String na_ore_type;

    /**
     *
     * APP/DATA/规模单位--
     *
     * @mbggenerated
     */
    private String na_scope_unit;

    /**
     *
     * 坐标系统1-54坐标,2-80坐标
     *
     * @mbggenerated
     */
    private Integer in_coordinate_system;

    /**
     *
     * APP/DATA/法定代表人
     *
     * @mbggenerated
     */
    private String na_legal_representative;

    /**
     *
     * APP/DATA/合并项目
     *
     * @mbggenerated
     */
    private String na_merge_item;

    /**
     *
     * APP/DATA/价款处置方式代码
     *
     * @mbggenerated
     */
    private Integer qt_cost_style;

    /**
     *
     * APP/DATA/投资额
     *
     * @mbggenerated
     */
    private Double qt_invest_fund;

    /**
     *
     *  应缴纳采矿权价款  
     *
     * @mbggenerated
     */
    private Double qt_mining_value;

    /**
     *
     * APP/DATA/注册资金单位
     *
     * @mbggenerated
     */
    private String qt_register_comp;

    /**
     *
     * APP/DATA/注册资金
     *
     * @mbggenerated
     */
    private Double qt_register_fund;

    /**
     *
     * APP/DATA/总储量
     *
     * @mbggenerated
     */
    private Double qt_reserves_total;

    /**
     *
     * APP/DATA/申请人信用代码
     *
     * @mbggenerated
     */
    private String na_apply_credit_code;

    /**
     *
     * APP/DATA/储量评审机构
     *
     * @mbggenerated
     */
    private String na_reserves_review_agcy;

    /**
     *
     * APP/DATA/储量评审时间
     *
     * @mbggenerated
     */
    private LocalDateTime na_reserves_review_date;

    /**
     *
     * APP/DATA/储量备案时间
     *
     * @mbggenerated
     */
    private LocalDateTime na_reserves_record_date;

    /**
     *
     * APP/DATA/储量评审备案情况
     *
     * @mbggenerated
     */
    private String na_reserves_record;

    /**
     *
     * APP/DATA/出让收益总额
     *
     * @mbggenerated
     */
    private Double qt_cost_total;

    /**
     *
     * APP/DATA/环保与复垦方案
     *
     * @mbggenerated
     */
    private String na_environment_plan;

    /**
     *
     * APP/DATA/基本情况
     *
     * @mbggenerated
     */
    private String na_plan_basic;

    /**
     *
     * APP/DATA/编制单位
     *
     * @mbggenerated
     */
    private String na_plan_write_agcy;

    /**
     *
     * APP/DATA/评审机构
     *
     * @mbggenerated
     */
    private String na_plan_review_agcy;

    /**
     *
     * APP/DATA/评审时间
     *
     * @mbggenerated
     */
    private LocalDateTime na_plan_review_date;

    /**
     *
     * APP/DATA/公告时间
     *
     * @mbggenerated
     */
    private LocalDateTime na_plan_notice_date;

    /**
     *
     * APP/DATA/变更原因
     *
     * @mbggenerated
     */
    private String na_change_reason;

    /**
     *
     * APP/DATA/延续理由
     *
     * @mbggenerated
     */
    private String na_continue_reason;

    /**
     *
     * APP/DATA/注销原因
     *
     * @mbggenerated
     */
    private String na_cancel_reason;

    /**
     *
     * APP/DATA/保有储量
     *
     * @mbggenerated
     */
    private String na_retain_reserves;

    /**
     *
     * APP/DATA/环保与复垦情况
     *
     * @mbggenerated
     */
    private String na_environment_protect;

    /**
     *
     * APP/DATA/损毁土地面积
     *
     * @mbggenerated
     */
    private Double qt_damage_land;

    /**
     *
     * APP/DATA/复垦土地面积
     *
     * @mbggenerated
     */
    private Double qt_reclaim_land;

    /**
     *
     * APP/DATA/是否验收合格
     *
     * @mbggenerated
     */
    private String is_check_pass;

    /**
     *
     * APP/DATA/是否代复垦
     *
     * @mbggenerated
     */
    private String is_replace_reclaim;

    /**
     *
     * APP/DATA/损毁耕地面积
     *
     * @mbggenerated
     */
    private Double qt_damage_farmland;

    /**
     *
     * APP/DATA/复垦费缴纳金额
     *
     * @mbggenerated
     */
    private Double qt_reclaim_money;

    /**
     *
     * APP/DATA/扩大范围变更
     *
     * @mbggenerated
     */
    private Integer is_change_enlarge;

    /**
     *
     * APP/DATA/缩小范围变更
     *
     * @mbggenerated
     */
    private Integer is_change_reduce;

    /**
     *
     * APP/DATA/变更开采主矿种
     *
     * @mbggenerated
     */
    private Integer is_change_mine;

    /**
     *
     * APP/DATA/变更开采方式
     *
     * @mbggenerated
     */
    private Integer is_change_mode;

    /**
     *
     * APP/DATA/变更采矿权人名称
     *
     * @mbggenerated
     */
    private Integer is_change_person;

    /**
     *
     * APP/DATA/采矿权转让变更
     *
     * @mbggenerated
     */
    private Integer is_change_transfer;

    /**
     *
     * APP/DATA/其他采矿权变更事项
     *
     * @mbggenerated
     */
    private Integer is_change_other;

    /**
     *
     *  申请序号  
     *
     * @mbggenerated
     */
    private String id_applyid;

    /**
     *
     *  申请人电话 
     *
     * @mbggenerated
     */
    private String na_tel;

    /**
     *
     *  申请人邮编 
     *
     * @mbggenerated
     */
    private String na_post;

    /**
     *
     *  项目审批机关  
     *
     * @mbggenerated
     */
    private String na_item_approve_gov;

    /**
     *
     *  批准文号  
     *
     * @mbggenerated
     */
    private String na_approve_code;

    /**
     *
     *  投资额单位 
     *
     * @mbggenerated
     */
    private String na_invest_comp;

    /**
     *
     *  资金来源  
     *
     * @mbggenerated
     */
    private String na_fund_origin;

    /**
     *
     *  开户银行  
     *
     * @mbggenerated
     */
    private String na_account_bank;

    /**
     *
     *  帐号  
     *
     * @mbggenerated
     */
    private String na_accounts;

    /**
     *
     *  采矿回采率 
     *
     * @mbggenerated
     */
    private Double qt_repeat_rate;

    /**
     *
     *  矿石贫化率 
     *
     * @mbggenerated
     */
    private Double qt_deficient_rate;

    /**
     *
     *  选矿回收率 
     *
     * @mbggenerated
     */
    private Double qt_callback_rate;

    /**
     *
     *  填表人 
     *
     * @mbggenerated
     */
    private String na_write_person;

    /**
     *
     *  矿权终止时间  
     *
     * @mbggenerated
     */
    private LocalDateTime dt_mine_end;

    /**
     *
     *  NA_CHECKUP_PERSON 
     *
     * @mbggenerated
     */
    private String na_checkup_person;

    /**
     *
     *  签发  
     *
     * @mbggenerated
     */
    private String na_signature;

    /**
     *
     *  复核  
     *
     * @mbggenerated
     */
    private String na_check;

    /**
     *
     *  审核  
     *
     * @mbggenerated
     */
    private String na_audit;

    /**
     *
     *  变更内容  
     *
     * @mbggenerated
     */
    private String na_change_content;

    /**
     *
     *  矿区编码  
     *
     * @mbggenerated
     */
    private Long qt_diggings_code;

    /**
     *
     *  价款处置方式  
     *
     * @mbggenerated
     */
    private String na_cost_style;

    /**
     *
     *  勘查许可证号  
     *
     * @mbggenerated
     */
    private String id_licenceid_perambulate;

    /**
     *
     *  划矿备案号 
     *
     * @mbggenerated
     */
    private String na_record_code;

    /**
     *
     *  原有效期起 
     *
     * @mbggenerated
     */
    private LocalDateTime dt_old_start;

    /**
     *
     *  原有效期止 
     *
     * @mbggenerated
     */
    private LocalDateTime dt_old_end;

    /**
     *
     *  填表时间  
     *
     * @mbggenerated
     */
    private LocalDateTime dt_write_date;

    /**
     *
     *  许可证副本说明 
     *
     * @mbggenerated
     */
    private String na_licence_note;

    /**
     *
     *  发证机关编码  
     *
     * @mbggenerated
     */
    private String na_gov_code;

    /**
     *
     *  发证机关名称  
     *
     * @mbggenerated
     */
    private String na_gov_name;

    /**
     *
     *  所在行政区名称 
     *
     * @mbggenerated
     */
    private String na_canton_name;

    /**
     *
     *  审查人意见 
     *
     * @mbggenerated
     */
    private String na_checkup_comment;

    /**
     *
     *  最终产品  
     *
     * @mbggenerated
     */
    private String na_finally_product;

    /**
     *
     *  探矿权取得方式 
     *
     * @mbggenerated
     */
    private String na_prospect_kind;

    /**
     *
     *  价款处置方式说明  
     *
     * @mbggenerated
     */
    private String na_cost_treament;

    /**
     *
     *  探明地质储量  
     *
     * @mbggenerated
     */
    private String na_geologic_reserves;

    /**
     *
     *  设计利用储量  
     *
     * @mbggenerated
     */
    private String na_design_reserves;

    /**
     *
     *  地质报告审批情况  
     *
     * @mbggenerated
     */
    private String na_report_approve;

    /**
     *
     *  矿石品位  
     *
     * @mbggenerated
     */
    private String na_mine_grade;

    /**
     *
     *  综合回收  
     *
     * @mbggenerated
     */
    private String na_integration_callback;

    /**
     *
     *  申请原因  
     *
     * @mbggenerated
     */
    private String na_change_opinion;

    /**
     *
     *  补偿费交纳情况 
     *
     * @mbggenerated
     */
    private String na_expiation;

    /**
     *
     *  使用费交纳情况 
     *
     * @mbggenerated
     */
    private String na_use_fee;

    /**
     *
     *  价款处置情况  
     *
     * @mbggenerated
     */
    private String na_value_disposure;

    /**
     *
     *  备注  
     *
     * @mbggenerated
     */
    private String na_appendix;

    /**
     *
     *  实地核查坐标  
     *
     * @mbggenerated
     */
    private String na_survey_coordinate;

    /**
     *
     *  实地核查意见  
     *
     * @mbggenerated
     */
    private String na_survey_comment;

    /**
     *
     *  实地核查单位  
     *
     * @mbggenerated
     */
    private String na_survey_company;

    /**
     *
     *  实地核查人 
     *
     * @mbggenerated
     */
    private String na_survey_person;

    /**
     *
     *  实地核查完成时间  
     *
     * @mbggenerated
     */
    private LocalDateTime dt_survey_date;

    /**
     *
     *  重叠核查意见  
     *
     * @mbggenerated
     */
    private String na_overlap_comment;

    /**
     *
     *  重叠核查单位  
     *
     * @mbggenerated
     */
    private String na_overlap_department;

    /**
     *
     *  重叠核查人 
     *
     * @mbggenerated
     */
    private String na_overlap_person;

    /**
     *
     *  重叠核查完成时间  
     *
     * @mbggenerated
     */
    private LocalDateTime dt_overlap_date;

    /**
     *
     *  实地核查状况  
     *
     * @mbggenerated
     */
    private Integer na_survey_state;

    /**
     *
     *  首设时间  
     *
     * @mbggenerated
     */
    private LocalDateTime dt_first_date;

    /**
     *
     * 项目状态 1=登记 2=公告
     *
     * @mbggenerated
     */
    private Integer prostatus;

    /**
     *
     * null
     *
     * @mbggenerated
     */
    private LocalDateTime create_time;

    /**
     *
     * null
     *
     * @mbggenerated
     */
    private String created_by;

    /**
     *
     * null
     *
     * @mbggenerated
     */
    private Boolean enable_;

    /**
     *
     * null
     *
     * @mbggenerated
     */
    private String last_modified_by;

    /**
     *
     * null
     *
     * @mbggenerated
     */
    private LocalDateTime update_time;
}